#!/bin/bash

/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/jtp_app_report?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table traffic_page_view_report  \
--export-dir /user/spark/warehouse/jtp_app_ads/ads_traffic_page_view_report  \
--input-fields-terminated-by "\001" \
--update-mode allowinsert \
--update-key "dt,recent_days,province,city" \
--num-mappers 1 \
--input-null-non-string '\\N' \
--input-null-string '\\N'